syStudent 
Logical Entity Name  syStudent 
Default Table Name  syStudent 
Physical Only  NO 
Definition 
 
Note 
 

syStudent Columns 
ColumnName  Domain  Datatype  NULL  Definition 
SSN    varchar(30)  YES 
 
AmTitleID    int  NO 
 
LastName    varchar(25)  NO 
 
FirstName    varchar(25)  NO 
 
NickName    varchar(14)  NO 
 
MaidenName    varchar(19)  NO 
 
Addr1    varchar(255)  NO 
 
Addr2    char(1)  YES 
 
City    varchar(25)  NO 
 
State    char(2)  NO 
 
Zip    char(10)  NO 
 
BadAddr    bit  NO 
 
SyCountryID    int  YES 
 
SyCountyID    int  NO 
 
Phone    char(16)  NO 
 
WorkPhone    char(16)  NO 
 
Workext    varchar(10)  NO 
 
BadPhone    bit  NO 
 
LeadDate    datetime  YES 
 
AmLeadTypeID    int  NO 
 
AmSexID    int  NO 
 
AmRaceID    int  NO 
 
AmNationalityID    int  NO 
 
AmMaritalID    int  NO 
 
DrivLicState    char(2)  NO 
 
DrivLic    char(20)  NO 
 
DOB    datetime  YES 
 
AlienNo    char(9)  YES 
 
AmAgencyID    int  NO 
 
AmCitizenID    int  NO 
 
email    varchar(50)  NO 
 
SySchoolStatusID    int  NO 
 
AmRepID    int  NO 
 
AmLeadSrcID(FK)    int  NO 
 
SyCampusID    int  NO 
 
AdProgramGroupID    int  NO 
 
AdProgramID    int  NO 
 
AdShiftID    int  NO 
 
StartDate    datetime  YES 
 
AmPrevEducID    int  NO 
 
AmHighSchoolID    int  NO 
 
AmCollegeID    int  YES 
 
HsGradDate    datetime  YES 
 
ARBalance    money  NO 
 
NextTranNum    smallint  NO 
 
ArAcctStat    char(2)  NO 
 
StmtLastDate    datetime  YES 
 
StmtBeginDate    datetime  YES 
 
StmtCloseDate    datetime  YES 
 
StmtComment    varchar(200)  NO 
 
DefaultAddressCode    char(1)  YES 
 
DefaultAddressID    int  YES 
 
PlEmployerID    int  NO 
 
plEmpStatusID    int  NO 
 
StuNum    char(10)  YES 
 
PIN    numeric(4, 0)  YES 
 
Comment    text  NO 
 
AmExtraCurrID    int  YES 
 
Active    bit  NO 
 
DataBlockIndicator    bit  NO 
 
ModFlag    char(1)  NO 
 
Userid    int  NO 
 
DateAdded    datetime  NO 
 
DateLstMod    datetime  NO 
 
ts    timestamp  NO 
 
SyStudentId(PK)    int  NO 
 
Disabled    char(1)  NO 
 
Vet    char(1)  NO 
 
OriginalAmRepID    int  YES 
 
CumGPA    numeric(11, 6)  YES 
 
CumGPAPoints    money  YES 
 
CurrentLDA    datetime  YES 
 
GPACredits    money  YES 
 
OriginalStartDate    datetime  YES 
 
OriginalExpStartDate    datetime  YES 
 
OtherPhone    char(16)  YES 
 
OtherEmail    varchar(50)  YES 
 
LastActivityDate    datetime  YES 
 
LastInterestDate    datetime  YES 
 
DefaultMasterAddressID(FK)    int  YES 
 
Suffix    char(3)  YES 
 
MiddleName    varchar(100)  YES 
 
NIStudent    bit  NO 
 
StudentIdentifier    varchar(44)  YES 
 
PrevEducGPA    numeric(11, 6)  YES 
 
HSGraduated    bit  NO 
 
HSGraduationSession    varchar(10)  YES 
 
HSDateEnrolled    datetime  YES 
 
HSLastDateAttended    datetime  YES 
 
HSStudRank    int  YES 
 
HSSchoolSize    int  YES 
 
HSTranscriptType    tinyint  YES 
 
HSStudLevel    tinyint  YES 
 
HSGradYear    varchar(4)  YES 
 
LastName_FirstFour    varchar(4)  YES 
 
Zip_FirstThree    varchar(3)  YES 
 
DBIModifiedDate    datetime  YES 
 
BestTimeToContact    varchar(10)  YES 
 
RawLastName    varchar(25)  YES 
 
RawFirstName    varchar(25)  YES 
 
RawPhone    varchar(16)  YES 
 
ACGEligReasonCode    char(2)  YES 
 
FARigorousHighSchoolProgramCodeID(FK)    int  YES 
 
CMSMSServiceProviderID(FK)    int  YES 
 
SubscribeToSMS    bit  NO 
 
MobileNumber    varchar(16)  YES 
 
SourceSystem    char(1)  NO 
 
IsHispanic    char(1)  YES 
 
CrmSuppressFlag    bit  NO 
 
DDVeteran    bit  NO 
 
HSAcademicGPA    numeric(11, 6)  YES 
 
AmSuffixID(FK)    int  YES 
 
AthleticID    varchar(20)  YES 
 
faGradPlusCounselingDate    datetime  YES 
 
InDistrict    bit  NO 
 
DefaultStipendsToEFT    bit  NO 
 
MI    AS (isnull(left([MiddleName],(1)),' '))   
 
SyPersonId(FK)    int  YES 
 
FullName    AS ((ltrim(rtrim([LastName]))+', ')+ltrim(rtrim(isnull([FirstName],''))))   
 
PreferredContactType    char(10)  YES 
 
PreferredName    char(10)  YES 
 
ExternalStudentIdentifier    char(10)  YES 
 

syStudent Primary and Unique Keys 
Key Name  Key Type  Keys 
syStudent_SyStudentID_U_C_IDX  PrimaryKey  SyStudentId 
SyStudent_LastName_NickName_SyStudentID_U_N_IDX  Index  LastName, NickName, SyStudentId 
SyStudent_SySchoolStatusID_Lastname_Firstname_SSN_Phone_SyStudentID_SyCampusId_U_N_IDX  Index  SySchoolStatusID, LastName, FirstName, SSN, Phone, SyStudentId, SyCampusID 
SyStudent_MaidenName_NickName_SyStudentID_U_N_IDX  Index  MaidenName, NickName, SyStudentId 
SyStudent_WorkPhone_SyCampusID_SyStudentID_U_N_IDX  Index  WorkPhone, SyCampusID, SyStudentId 
SyStudent_Phone_SyCampusID_SyStudentID_U_N_IDX  Index  Phone, SyCampusID, SyStudentId 
SyStudent_MaidenName_FirstName_SyStudentID_U_N_IDX  Index  MaidenName, FirstName, SyStudentId 
syStudent_SyStudentId_Email_U_N_IDX  Index  SyStudentId, email 
SyStudent_Email_SyCampusID_SyStudentID_U_N_IDX  Index  email, SyCampusID, SyStudentId 

syStudent Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
amLeadSrc  Non-Identifying  One To Zero or More  FK_syStudent_AmLeadSrcID_AmLeadSrc_AmLeadSrcID      AmLeadSrcID  NO  YES 
CMSMSServiceProvider  Non-Identifying  Zero or One to Zero or More  FK_SyStudent_CMSMSServiceProviderID_CMSMSServiceProvider_CMSMSServiceProviderID      CMSMSServiceProviderID  NO  YES 
SyAddress  Non-Identifying  Zero or One to Zero or More  FK_syStudent_DefaultMasterAddressID_SyAddress_SyAddressID      DefaultMasterAddressID  NO  YES 
FARigorousHighSchoolProgramCode  Non-Identifying  Zero or One to Zero or More  FK_SyStudent_FARigorousHighSchoolProgramCodeID_FARigorousHighSchoolProgramCode_FARigorousHighSchoolProgramCodeID      FARigorousHighSchoolProgramCodeID  NO  YES 
AmSuffix  Non-Identifying  Zero or One to Zero or More  FK_SyStudentAmSuffixID_AmSuffixAmSuffixID      AmSuffixID  NO  YES 
SyPerson  Non-Identifying  Zero or One to Zero or More  FK_SyStudentSyPersonId_SyPersonSyPersonId      SyPersonId  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 
AdAttend_Proxy  Non-Identifying  One To Zero or More  FK_AdAttend_Proxy_SyStudentId_SyStudent_SyStudentId        NO  YES 
AdEnroll  Non-Identifying  One To Zero or More  FK_AdEnroll_SyStudentID_syStudent_SyStudentID        NO  YES 
AdEnrollSchedStatusChanges  Non-Identifying  One To Zero or More  FK_AdEnrollSchedStatusChangesSyStudentID_SyStudentSyStudentID        NO  YES 
AdEnrollSchedStatusHistory  Non-Identifying  One To Zero or More  FK_AdEnrollSchedStatusHistory_syStudentID_syStudent_syStudentID        NO  YES 
AdEnrollTerm_RebuildRelationshipLog  Non-Identifying  One To Zero or More  FK_AdEnrollTerm_RebuildRelationshipLog_SyStudentID_SyStudent_SyStudentID        NO  YES 
AdEnrollTerm  Non-Identifying  One To Zero or More  FK_AdEnrollTerm_SyStudentID_syStudent_SyStudentID        NO  YES 
AdEnrollTermRelationshipException  Non-Identifying  One To Zero or More  FK_AdEnrollTermRelationshipException_syStudentID_syStudent_syStudentID        NO  YES 
AdGainfulEmploymentReportingDetails  Non-Identifying  One To Zero or More  FK_AdGainfulEmploymentReportingDetailsSyStudentID_SyStudentSyStudentID        NO  YES 
AdGPAStudentCourse  Non-Identifying  One To Zero or More  FK_AdGPAStudentCourseSyStudentID_SyStudentSyStudentID        NO  YES 
AdGPAStudent  Non-Identifying  One To Zero or More  FK_AdGPAStudentSyStudentID_SyStudentSyStudentID        NO  YES 
AdRegistrationLock  Non-Identifying  One To Zero or More  FK_AdRegistrationLockSyStudentID_SyStudentSyStudentID        NO  YES 
AdStudentDegreePathway  Non-Identifying  One To Zero or More  FK_AdStudentDegreePathway_SyStudentId_SyStudent_SyStudentId        NO  YES 
AdStudentTermSequenceHeader  Non-Identifying  One To Zero or More  FK_AdStudentTermSequenceHeader_SyStudentID_SyStudent_SyStudentID        NO  YES 
AdStudentTransferHeader  Non-Identifying  One To Zero or More  FK_AdStudentTransferHeader_SyStudentID_syStudent_SyStudentID        NO  YES 
AmApplicant  Identifying  One To Zero or More  FK_AmApplicant_SyStudentID_SyStudent_SyStudentID        NO  YES 
AmCollegeTransfer  Non-Identifying  One To Zero or More  FK_AmCollegeTransfer.SyStudentID_SyStudent.SyStudentID        NO  YES 
AmCollegeTransferAdvance  Non-Identifying  One To Zero or More  FK_AmCollegeTransferAdvance_SyStudentId_syStudent_SyStudentId        NO  YES 
CmDocument  Non-Identifying  One To Zero or More  FK_CmDocument_SyStudentID_syStudent_SyStudentID        NO  YES 
CmDocumentPermit  Non-Identifying  One To Zero or More  FK_CmDocumentPermitSyStudentID_SyStudentSyStudentID        NO  YES 
CmFERPADirStudentRelation  Non-Identifying  One To Zero or More  FK_CmFERPADirStudentRelationSyStudentID_SyStudentSyStudentID        NO  YES 
CmFERPAStudentInfoRequest  Non-Identifying  One To Zero or More  FK_CmFERPAStudentInfoRequestSyStudentID_SyStudentSyStudentID        NO  YES 
CmIncidentStudent  Non-Identifying  One To Zero or More  FK_CmIncidentStudent.SyStudentID_SyStudent.SyStudentID        NO  YES 
CmPreferredContactMethod  Non-Identifying  One To Zero or More  FK_CmPreferredContactMethod_SyStudentID_syStudent_SyStudentID        NO  YES 
CmResidencyStudentRelation  Non-Identifying  One To Zero or More  FK_CmResidencyStudentRelation_SyStudentID_SyStudent_SyStudentID        NO  NO 
FaAwardLetterQueue  Non-Identifying  One To Zero or More  FK_FaAwardLetterQueue_SyStudentID_SyStudent_SyStudentID        NO  YES 
FaCampusVantageWorkStudyPayroll  Non-Identifying  One To Zero or More  FK_FaCampusVantageWorkStudyPayroll_SyStudentId_SyStudent_SyStudentId        NO  YES 
FaCorrections00  Non-Identifying  One To Zero or More  FK_FaCorrections00_SyStudentID_syStudent_SyStudentID        NO  YES 
FaEstimate  Non-Identifying  One To Zero or More  FK_FaEstimate_SyStudentID_syStudent_SyStudentID        NO  YES 
FaEstimateAward  Non-Identifying  One To Zero or More  FK_FaEstimateAward_SyStudentID_syStudent_SyStudentID        NO  YES 
FaEstimateAY  Identifying  One To Zero or More  FK_FaEstimateAY_SyStudentID_syStudent_SyStudentID        NO  YES 
FaFAFSA04  Non-Identifying  One To Zero or More  FK_FaFAFSA04_SyStudentID_syStudent_SyStudentID        NO  YES 
FaFAFSA08  Non-Identifying  One To Zero or More  FK_FaFAFSA08_SyStudentID_SyStudent_SyStudentID        NO  YES 
FaFAFSA09  Non-Identifying  One To Zero or More  FK_FaFAFSA09_SyStudentID_SyStudent_SyStudentID        NO  YES 
FaFAFSA10  Non-Identifying  One To Zero or More  FK_FaFAFSA10_SyStudentID_SyStudent_SyStudentID        NO  YES 
FaFAFSA11  Non-Identifying  One To Zero or More  FK_FaFAFSA11_SyStudentID_SyStudent_SyStudentID        NO  YES 
FaFAFSA12  Non-Identifying  One To Zero or More  FK_FaFAFSA12_SyStudentID_SyStudent_SyStudentID        NO  YES 
FaFafsa  Non-Identifying  One To Zero or More  FK_FaFafsaSyStudentID_SyStudentSyStudentID        NO  YES 
FaHopeBenchmarkTierEvaluationResult  Non-Identifying  One To Zero or More  FK_FaHopeBenchmarkTierEvaluationResultSyStudentID_SyStudentSyStudentID        NO  YES 
FaISIRcCode  Identifying  One To Zero or More  FK_FaISIRcCode_SyStudentID_SyStudent_SyStudentID        NO  YES 
FaISIRCorrection  Non-Identifying  One To Zero or More  FK_FaISIRCorrectionSyStudentId_SyStudentSyStudentId        NO  YES 
FAISIRMatch  Non-Identifying  One To Zero or More  FK_FAISIRMatch_SyStudentID_SyStudent_SyStudentID        NO  YES 
FaISIRStudentMatch  Non-Identifying  One To Zero or More  FK_FaISIRStudentMatchSyStudentId_SyStudentSyStudentId        NO  YES 
FaLoanApplication  Non-Identifying  One To Zero or More  FK_FaLoanApplication_SyStudentID_SyStudent_SyStudentID        NO  YES 
FaMultiDisbException  Non-Identifying  One To Zero or More  FK_FaMultiDisbException_SyStudentID_SyStudent_SyStudentID        NO  YES 
FaNSLDSStudent  Non-Identifying  One To Zero or More  FK_FaNSLDSStudent_SyStudentID_SyStudent_SyStudentID        NO  YES 
FaShoppingSheet  Non-Identifying  One To Zero or More  FK_FaShoppingSheet_syStudent        NO  YES 
FaStudentAid  Non-Identifying  One To Zero or More  FK_FaStudentAid_SyStudentID_syStudent_SyStudentID        NO  YES 
FaStudentAidCashPlanHistory  Non-Identifying  One To Zero or More  FK_FaStudentAidCashPlanHistory_SyStudent_SyStudentId        NO  YES 
FaStudentAutoAwardLog  Non-Identifying  One To Zero or More  FK_FaStudentAutoAwardLog_SyStudentId_SyStudent_SyStudentId        NO  YES 
FaStudentDocs  Non-Identifying  One To Zero or More  Fk_FaStudentDocs_SyStudentID_SyStudent_SyStudentID        NO  YES 
FaStudentFAFSA  Non-Identifying  One To Zero or More  FK_FaStudentFAFSASyStudentId_SyStudentSyStudentId        NO  YES 
FaStudentFundSource  Non-Identifying  One To Zero or More  FK_FaStudentFundSourceSyStudentId_SyStudentSyStudentId        NO  YES 
FaStudentMaster  Non-Identifying  One To Zero or More  FK_FaStudentMaster_SyStudentId_SyStudent_SyStudentId        NO  YES 
FaStudentPell  Non-Identifying  One To Zero or More  FK_FaStudentPell_SyStudentID_syStudent_SyStudentID        NO  YES 
FaTsmMain  Non-Identifying  One To Zero or More  FK_FaTsmMainSyStudentID_SyStudent_SyStudentID        NO  YES 
FaVerificationHistory  Non-Identifying  One To Zero or More  FK_FaVerificationHistory_SyStudentID_SyStudent_SyStudentID        NO  YES 
HsBuildingRoomsStudents  Non-Identifying  One To Zero or More  FK_HsBuildingRoomsStudents_SyStudentID_SyStudent_SyStudentID        NO  YES 
HsRoomMateMatchStudent  Non-Identifying  One To Zero or More  FK_HsRoomMateMatchStudent_SyStudentID_SyStudent_SyStudentID        NO  YES 
HsStudentApplication  Non-Identifying  One To Zero or More  FK_HsStudentApplication_SyStudentID_SyStudent_SyStudentID        NO  YES 
HsStudentApplicationAnswers  Non-Identifying  One To Zero or More  FK_HsStudentApplicationAnswers_SyStudentID_SyStudent_SyStudentID        NO  YES 
HSStudentLeaseHistory  Non-Identifying  One To Zero or More  FK_HSStudentLeaseHistory_SyStudentID_SyStudent_SyStudentID        NO  YES 
HsStudentResponseComments  Non-Identifying  One To Zero or More  FK_HsStudentResponseComments_SyStudentID_SyStudent_SyStudentID        NO  YES 
PlStudentApplyHist  Non-Identifying  One To Zero or More  FK_PlStudentApplyHist_SyStudentID_SyStudent_SyStudentID        NO  YES 
PlStudentInSchool  Non-Identifying  One To Zero or More  FK_PlStudentInSchool_SyStudentID_SyStudent_SyStudentID        NO  YES 
PlStudentSearchAgent  Non-Identifying  One To Zero or More  FK_PlStudentSearchAgent_SyStudentID_SyStudent_SyStudentID        NO  YES 
Sa1098TBatchDetail  Identifying  One To Zero or More  FK_Sa1098TBatchDetail_SyStudentID_syStudent_SyStudentID        NO  YES 
SaBillingStatementBatchDetailCharges  Non-Identifying  One To Zero or More  FK_SaBillingStatementBatchDetailCharges_SyStudentID_SyStudent_SySTudentID        NO  YES 
SaBillingStatementBatchDetailFA  Non-Identifying  One To Zero or More  FK_SaBillingStatementBatchDetailFA_SyStudentID_SyStudent_SySTudentID        NO  YES 
SaBillingStatementBatchDetailPayments  Non-Identifying  One To Zero or More  FK_SaBillingStatementBatchDetailPayments_SyStudentID_SyStudent_SySTudentID        NO  YES 
SaBillingStatementBatchStudent  Non-Identifying  One To Zero or More  FK_SaBillingStatementBatchStudent_SyStudentID_SyStudent_SyStudentID        NO  YES 
SaBillingStatementBatchStudentDetail  Non-Identifying  One To Zero or More  FK_SaBillingStatementBatchStudentDetail_SyStudentID_SyStudent_SyStudentID        NO  YES 
SaBillingStatementBatchSubsidiaryDetail  Non-Identifying  One To Zero or More  FK_SaBillingStatementBatchSubsidiaryDetail_SyStudentID_SyStudent_SySTudentID        NO  YES 
SaCollections  Non-Identifying  One To Zero or More  FK_SaCollections_SyStudentID_SyStudent_SyStudentID        NO  YES 
SaDisbReceiptNotification  Non-Identifying  One To Zero or More  FK_SaDisbReceiptNotificationSyStudentID_SyStudentSyStudentID        NO  YES 
SaPaymentApply  Non-Identifying  One To Zero or More  FK_SaPaymentApply_SyStudentId_SyStudent_SyStudentId        NO  YES 
SaPendingCharge  Non-Identifying  One To Zero or More  FK_saPendingCharge.SyStudentID_SyStudent.SyStudentID        NO  YES 
SaStatementHistory  Non-Identifying  One To Zero or More  FK_SaStatementHistory_SyStudentID_SyStudent_SyStudentID        NO  YES 
SaStudentBankAccount  Non-Identifying  One To Zero or More  FK_SaStudentBankAccount_SyStudentID_syStudent_SyStudentID        NO  YES 
SsAthleticDetail  Non-Identifying  One To Zero or More  FK_SsAthleticDetailSyStudentID_SyStudentSyStudentID        NO  YES 
SsStudentDisabilityDetail  Non-Identifying  One To Zero or More  FK_SsStudentDisabilityDetailSyStudentID_SyStudentSyStudentID        NO  YES 
SsStudentServiceAssociation  Non-Identifying  One To Zero or More  FK_SsStudentServiceAssociation_SyStudentID_SyStudent_SyStudentID        NO  YES 
SsStudentVeteranDetail  Non-Identifying  One To Zero or More  FK_SsStudentVeteranDetailSyStudentID_SyStudentSyStudentID        NO  YES 
SsStudRoommate  Identifying  One To Zero or More  FK_SsStudRoommate_RoommateSyStudentID_syStudent_SyStudentID        NO  YES 
SyAudit_AdAttend  Non-Identifying  One To Zero or More  FK_SyAudit_AdAttend_SyStudentId_SyStudent_SyStudentId        NO  YES 
SyAudit_AdAttendArchive  Non-Identifying  One To Zero or More  FK_SyAudit_AdAttendArchive_SyStudentId_SyStudent_SyStudentId        NO  YES 
SyAudit_AmDeposit  Non-Identifying  One To Zero or More  FK_SyAudit_AmDeposit_RecordId_SyStudent_SyStudentId        NO  YES 
SyAudit_AmProspectTest  Non-Identifying  One To Zero or More  FK_SyAudit_AmProspectTest_SyStudentID_SyStudent_SyStudentID        NO  YES 
SyAudit_CmDocument  Non-Identifying  One To Zero or More  FK_SyAudit_CmDocument_SyStudentID_SyStudent_SyStudentID        NO  YES 
SyAudit_FaStateEligibility  Non-Identifying  One To Zero or More  FK_SyAudit_FaStateEligibilitySyStudentID_SyStudentSyStudentID        NO  YES 
SyAudit_SyStudent  Non-Identifying  One To Zero or More  FK_SyAudit_SyStudent_RecordID_syStudent_SyStudentID        NO  YES 
SyCornerstoneBatchDetail  Non-Identifying  One To Zero or More  FK_SyCornerstoneBatchDetail_SyStudentID_SyStudent_SyStudentId        NO  YES 
SyGPACalculateQueue  Non-Identifying  One To Zero or More  FK_SyGPACalculateQueueSyStudentID_SyStudentSyStudentID        NO  YES 
SyIndicatorStudentRelation  Non-Identifying  One To Zero or More  FK_SyIndicatorStudentRelation_SyStudentId_syStudent_SyStudentId        NO  YES 
SyServiceMessageSourceRecord  Non-Identifying  One To Zero or More  FK_SyServiceMessageSourceRecordSyStudentId_SyStudentSyStudentId        NO  YES 
SySEVISBatchDetail  Non-Identifying  One To Zero or More  FK_SySEVISBatchDetail_SyStudentID_syStudent_SyStudentID        NO  YES 
SySEVISChanges  Non-Identifying  One To Zero or More  FK_SySEVISChanges_SyStudentID_syStudent_SyStudentID        NO  YES 
SySEVISSiteOfActivity  Non-Identifying  One To Zero or More  FK_SySEVISSiteOfActivity_SyStudentID_syStudent_SyStudentID        NO  YES 
SyStudentAmRace  Non-Identifying  One To Zero or More  FK_SyStudentAmRaceSyStudentID_SyStudentSyStudentID        NO  YES 
SyStudentExternalDMConfiguration  Non-Identifying  One To Zero or More  FK_SyStudentExternalDMConfiguration_SyStudentId_SyStudent_SyStudentId        NO  YES 
SyStudentExternalDMIdentifierMap  Non-Identifying  One To Zero or More  FK_SyStudentExternalDMIdentifierMap_SyStudentId_SyStudent_SyStudentId        NO  YES 
SyStudentExternalMap  Non-Identifying  One To Zero or More  FK_SyStudentExternalMap_SyStudentId_SyStudent_SyStudentId        NO  YES 
SyStudentExternalMap  Non-Identifying  One To Zero or More  FK_syStudentExternalMapsyStudentId_syStudentsyStudentId        NO  YES 
SyStudentNI  Non-Identifying  One To Zero or More  FK_SyStudentNI_SyStudentID_syStudent_SyStudentID        NO  YES 
SyStudentNIDependent  Non-Identifying  One To Zero or More  FK_SyStudentNIDependent_SyStudentID_syStudent_SyStudentID        NO  YES 
SyStudentOrganizationContact  Non-Identifying  One To Zero or More  FK_SyStudentOrganizationContact_SyStudentId_SyStudent_SyStudentID        NO  YES 
SyStudentResidencyStatus  Non-Identifying  One To Zero or More  FK_SyStudentResidencyStatus_SyStudentId_SyStudent_SyStudentId        NO  NO 

syStudent Check Constraints 
Check Constraint Name  CheckConstraint 
Chk_SyStudent_LastInterestDate_OriginalStartDate  (([LastInterestDate] > [OriginalStartDate] or [LastInterestDate] is null and [OriginalStartDate] is null or [LastInterestDate] is null and [OriginalStartDate] is not null) and ((not([LastInterestDate] is not null and [OriginalStartDate] is null))))